﻿CREATE PROCEDURE [acms].[UserSecurity_GetByEmailAddress]
	@EmailAddress varchar(100),
	@SiteId int
AS
	SELECT *
	FROM UserSecurity_View
	WHERE EmailAddress = @EmailAddress
		and IsNull(SiteId, @SiteId) = @SiteId
RETURN 0;